  
CREATE EXTERNAL TABLE jms_dm.dm_sqs_summary_net_dt(
    `site_code` string COMMENT '站点code',
    `site_name` string COMMENT '站点name',
    `network_type` int COMMENT '网点类型',
    `taking_count` int COMMENT '揽收量',
    `send_count`   int COMMENT '发件量',
    `arrival_count` int COMMENT '到件量',
    `deliver_count` int COMMENT '派件量',
    `sign_fact_count` int COMMENT '签收量')
COMMENT '收发到派签-汇总表'
PARTITIONED BY ( 
  `dt` string COMMENT '时间分区(yyyy-MM-dd)')
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  'hdfs://yl-bg-hdp/dw/hive/jms_dm.db/external/dm_sqs_summary_net_dt'
  